/*
 Navicat Premium Dump SQL

 Source Server         : 127Root
 Source Server Type    : MariaDB
 Source Server Version : 101002 (10.10.2-MariaDB-1:10.10.2+maria~ubu2204)
 Source Host           : 127.0.0.1:3306
 Source Schema         : melon

 Target Server Type    : MariaDB
 Target Server Version : 101002 (10.10.2-MariaDB-1:10.10.2+maria~ubu2204)
 File Encoding         : 65001

 Date: 09/05/2025 21:03:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for act_ext_audit
-- ----------------------------
DROP TABLE IF EXISTS `act_ext_audit`;
CREATE TABLE `act_ext_audit` (
  `uid` bigint(20) NOT NULL COMMENT '业务ID',
  `area_code` varchar(50) NOT NULL COMMENT '主题编码',
  `data_type` varchar(50) NOT NULL COMMENT '数据类型;业务决定的枚举',
  `task_id` varchar(50) DEFAULT NULL COMMENT '任务进度ID;绑定流程编码',
  `data_id` varchar(50) NOT NULL COMMENT '数据ID',
  `work_flow_id` varchar(50) NOT NULL COMMENT '运行实例ID',
  `audit_flag` int(11) DEFAULT NULL COMMENT '审核状态',
  `own_dept_id` varchar(50) DEFAULT NULL COMMENT '归属部门',
  `data_desc` text DEFAULT NULL COMMENT '数据描述',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `idu_audit_gid` (`area_code`,`data_type`,`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='扩展审核状态';

-- ----------------------------
-- Records of act_ext_audit
-- ----------------------------
BEGIN;
INSERT INTO `act_ext_audit` (`uid`, `area_code`, `data_type`, `task_id`, `data_id`, `work_flow_id`, `audit_flag`, `own_dept_id`, `data_desc`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860638017138941952, 'AREA01', 'model', 'taskId_a1d472007c50', 'M1679005573089701888', '8', 3, NULL, '编码：T0000 名称：模板模型', 'admin', '2024-11-24 18:54:06', 'admin', '2024-11-24 20:50:42', NULL, NULL);
INSERT INTO `act_ext_audit` (`uid`, `area_code`, `data_type`, `task_id`, `data_id`, `work_flow_id`, `audit_flag`, `own_dept_id`, `data_desc`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860655791743684608, 'AREA01', 'model', 'task_7e1c50bd0eb8', 'M1679005573089702001', '2511', 2, NULL, '编码：T0001 名称：模板模型01', 'admin', '2024-11-24 20:04:44', 'admin', '2024-11-24 20:05:19', NULL, NULL);
INSERT INTO `act_ext_audit` (`uid`, `area_code`, `data_type`, `task_id`, `data_id`, `work_flow_id`, `audit_flag`, `own_dept_id`, `data_desc`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656144698560512, 'AREA01', 'model', 'task_7e1c50bd0eb8', 'M1679005573089702002', '2521', 3, NULL, '编码：T0002 名称：模板模型02', 'admin', '2024-11-24 20:06:08', 'admin', '2024-11-24 20:06:08', NULL, NULL);
INSERT INTO `act_ext_audit` (`uid`, `area_code`, `data_type`, `task_id`, `data_id`, `work_flow_id`, `audit_flag`, `own_dept_id`, `data_desc`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656351792320512, 'AREA01', 'model', 'taskId_a1d472007c50', 'M1679005573089702003', '2531', 0, NULL, '编码：T0003 名称：模板模型03', 'admin', '2024-11-24 20:06:58', 'admin', '2024-11-24 20:39:55', NULL, NULL);
INSERT INTO `act_ext_audit` (`uid`, `area_code`, `data_type`, `task_id`, `data_id`, `work_flow_id`, `audit_flag`, `own_dept_id`, `data_desc`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656447443423232, 'AREA01', 'model', 'taskId_a1d472007c50', 'M1679005573089702004', '2541', 0, NULL, '编码：T0004 名称：模板模型04', 'admin', '2024-11-24 20:07:21', 'admin', '2024-11-24 20:39:55', NULL, NULL);
INSERT INTO `act_ext_audit` (`uid`, `area_code`, `data_type`, `task_id`, `data_id`, `work_flow_id`, `audit_flag`, `own_dept_id`, `data_desc`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656496353202176, 'AREA01', 'model', 'taskId_a1d472007c50', 'M1679005573089702005', '2551', 3, NULL, '编码：T0005 名称：模板模型05', 'admin', '2024-11-24 20:07:32', 'admin', '2024-11-24 20:46:07', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_ext_bind
-- ----------------------------
DROP TABLE IF EXISTS `act_ext_bind`;
CREATE TABLE `act_ext_bind` (
  `uid` bigint(20) NOT NULL COMMENT '业务ID',
  `area_code` varchar(50) NOT NULL COMMENT '主题编码',
  `data_type` varchar(50) NOT NULL COMMENT '数据类型;业务决定的枚举',
  `flow_code` varchar(50) NOT NULL COMMENT '流程编码;绑定流程编码',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `idu_bind_gid` (`area_code`,`data_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工作流扩展绑定';

-- ----------------------------
-- Records of act_ext_bind
-- ----------------------------
BEGIN;
INSERT INTO `act_ext_bind` (`uid`, `area_code`, `data_type`, `flow_code`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860636870391062528, 'AREA01', 'model', 'FLOW0001', '0000', '2024-11-24 18:49:33', '0000', '2024-11-24 18:49:33', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_ext_def
-- ----------------------------
DROP TABLE IF EXISTS `act_ext_def`;
CREATE TABLE `act_ext_def` (
  `uid` bigint(20) NOT NULL COMMENT '业务ID',
  `area_code` varchar(50) DEFAULT NULL COMMENT '主题编码',
  `flow_code` varchar(50) DEFAULT NULL COMMENT '流程编码',
  `flow_name` varchar(100) DEFAULT NULL COMMENT '流程名称',
  `flow_version` int(11) DEFAULT NULL COMMENT '流程版本',
  `act_model_id` varchar(100) DEFAULT NULL COMMENT 'Act模型ID;Model::getId',
  `act_flow_id` varchar(100) DEFAULT NULL COMMENT 'Act定义ID;ProcessDefinition::getId',
  `audit_flag` int(11) DEFAULT NULL COMMENT '审核标记',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工作流扩展定义';

-- ----------------------------
-- Records of act_ext_def
-- ----------------------------
BEGIN;
INSERT INTO `act_ext_def` (`uid`, `area_code`, `flow_code`, `flow_name`, `flow_version`, `act_model_id`, `act_flow_id`, `audit_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860629783443365888, 'AREA01', 'FLOW0001', '工作流0001', 0, '1', 'FLOW0001:1:7', 1, '0000', '2024-11-24 18:21:23', '0000', '2024-11-24 18:21:23', NULL, '备注：第0001个测试流程');
COMMIT;

-- ----------------------------
-- Table structure for act_ext_flow_log
-- ----------------------------
DROP TABLE IF EXISTS `act_ext_flow_log`;
CREATE TABLE `act_ext_flow_log` (
  `uid` bigint(20) NOT NULL COMMENT '业务ID',
  `area_code` varchar(50) NOT NULL COMMENT '主题编码',
  `data_type` varchar(50) NOT NULL COMMENT '数据类型;业务决定的枚举',
  `data_id` varchar(50) NOT NULL COMMENT '数据ID',
  `work_flow_id` varchar(50) DEFAULT NULL COMMENT '运行实例ID',
  `audit_flag` varchar(255) DEFAULT NULL COMMENT '审核状态',
  `top_flag` int(11) DEFAULT NULL COMMENT '最新标记;1是0否',
  `decision_name` varchar(50) DEFAULT NULL COMMENT '操作名称',
  `message` varchar(100) DEFAULT NULL COMMENT '审核意见',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  KEY `idx_log_group_id` (`area_code`,`data_type`,`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='流程日志';

-- ----------------------------
-- Records of act_ext_flow_log
-- ----------------------------
BEGIN;
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860638017252188160, 'AREA01', 'model', 'M1679005573089701888', '8', '2', 0, '提交', '提交', 'admin', '2024-11-27 20:16:34', 'admin', '2024-11-24 20:50:42', NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860655791919845376, 'AREA01', 'model', 'M1679005573089702001', '2501', '2', 0, '提交', '提交', 'admin', '2024-11-27 20:16:37', 'admin', '2024-11-24 20:05:19', NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860655935977410560, 'AREA01', 'model', 'M1679005573089702001', '2511', '2', 1, '提交', '提交', 'admin', '2024-11-27 20:16:49', NULL, NULL, NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656144761475072, 'AREA01', 'model', 'M1679005573089702002', '2521', '2', 1, '提交', '提交', 'admin', '2024-11-27 20:16:53', NULL, NULL, NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656351851040768, 'AREA01', 'model', 'M1679005573089702003', '2531', '2', 0, '提交', '提交', 'admin', '2024-11-27 20:16:55', 'admin', '2024-11-24 20:39:55', NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656447489560576, 'AREA01', 'model', 'M1679005573089702004', '2541', '2', 0, '提交', '提交', 'admin', '2024-11-27 20:16:58', 'admin', '2024-11-24 20:39:55', NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860656496403533824, 'AREA01', 'model', 'M1679005573089702005', '2551', '2', 0, '提交', '提交', 'admin', '2024-11-27 20:17:00', 'admin', '2024-11-24 20:46:07', NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860664643528597504, 'AREA01', 'model', 'M1679005573089702003', NULL, '0', 1, '拒绝', '同意', 'admin', '2024-11-27 20:17:02', NULL, NULL, NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860664643927056384, 'AREA01', 'model', 'M1679005573089702004', NULL, '0', 1, '拒绝', '同意', 'admin', '2024-11-27 20:17:05', NULL, NULL, NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860666204359114752, 'AREA01', 'model', 'M1679005573089702005', '2551', '3', 1, '同意', '同意', 'admin', '2024-11-27 20:17:08', NULL, NULL, NULL, NULL);
INSERT INTO `act_ext_flow_log` (`uid`, `area_code`, `data_type`, `data_id`, `work_flow_id`, `audit_flag`, `top_flag`, `decision_name`, `message`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860667357717217280, 'AREA01', 'model', 'M1679005573089701888', '8', '3', 1, '同意', '同意', 'admin', '2024-11-27 20:17:10', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_ext_todo
-- ----------------------------
DROP TABLE IF EXISTS `act_ext_todo`;
CREATE TABLE `act_ext_todo` (
  `uid` bigint(20) NOT NULL COMMENT '业务ID',
  `pid` bigint(20) NOT NULL COMMENT '审核ID',
  `user_id` varchar(50) NOT NULL COMMENT '用户ID',
  `dept_id` varchar(50) NOT NULL COMMENT '部门ID',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名称',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  KEY `idx_todo_pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='扩展代办';

-- ----------------------------
-- Records of act_ext_todo
-- ----------------------------
BEGIN;
INSERT INTO `act_ext_todo` (`uid`, `pid`, `user_id`, `dept_id`, `user_name`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES (1860655935947411458, 1860655791743684608, 'admin', '103', '瓜瓜', 'admin', '2024-11-24 20:05:19', 'admin', '2024-11-24 20:05:19', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for dma_gys0001_idx
-- ----------------------------
DROP TABLE IF EXISTS `dma_gys0001_idx`;
CREATE TABLE `dma_gys0001_idx` (
  `uid` bigint(20) NOT NULL COMMENT '主键ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID;层级模型',
  `mid` bigint(20) DEFAULT NULL COMMENT '主线ID;扩展模型',
  `mco` varchar(100) DEFAULT NULL COMMENT '主编码;右模糊查询',
  `lco` varchar(100) DEFAULT NULL COMMENT '层级编码;右模糊查询',
  `type_src` varchar(10) DEFAULT NULL COMMENT '来源类型;0界面 1导入 2接口 3ETL 4其他',
  `task_id` varchar(50) DEFAULT NULL COMMENT '任务ID',
  `task_state` int(11) NOT NULL DEFAULT 0 COMMENT '任务运行态;0未开始1运行中3暂停4已完成',
  `data_flag` int(11) NOT NULL DEFAULT 10 COMMENT '数据状态',
  `mvs` int(11) NOT NULL DEFAULT 0 COMMENT '模型版本',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '数据版本',
  `c01` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c02` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c03` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c04` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c05` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c06` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c07` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c08` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c09` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c10` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c11` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c12` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c13` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c14` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c15` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `n01` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n02` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n03` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n04` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n05` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `d01` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d02` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d03` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d04` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d05` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `vip_level` int(11) NOT NULL DEFAULT 0 COMMENT '访问级别',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '提报单位',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `create_by` varchar(32) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) NOT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
  PRIMARY KEY (`uid`),
  KEY `ida_gys0001_code_mas` (`mco`),
  KEY `ida_gys0001_pid` (`pid`),
  KEY `ida_gys0001_mid` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据A索引表';

-- ----------------------------
-- Records of dma_gys0001_idx
-- ----------------------------
BEGIN;
INSERT INTO `dma_gys0001_idx` (`uid`, `pid`, `mid`, `mco`, `lco`, `type_src`, `task_id`, `task_state`, `data_flag`, `mvs`, `version`, `c01`, `c02`, `c03`, `c04`, `c05`, `c06`, `c07`, `c08`, `c09`, `c10`, `c11`, `c12`, `c13`, `c14`, `c15`, `n01`, `n02`, `n03`, `n04`, `n05`, `d01`, `d02`, `d03`, `d04`, `d05`, `remark`, `vip_level`, `dept_id`, `tenant_id`, `create_by`, `create_time`, `update_by`, `update_time`, `revision`) VALUES (1890741108959744000, NULL, NULL, '11', NULL, NULL, NULL, 0, 10, 0, 0, '11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '11', NULL, '1', '2025-02-15 20:33:03', '1', '2025-02-15 20:33:03', 0);
COMMIT;

-- ----------------------------
-- Table structure for dma_gys0001_val
-- ----------------------------
DROP TABLE IF EXISTS `dma_gys0001_val`;
CREATE TABLE `dma_gys0001_val` (
  `uid` bigint(20) NOT NULL COMMENT '主键ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID;层级模型',
  `mid` bigint(20) DEFAULT NULL COMMENT '主线ID;扩展模型',
  `mvs` int(11) NOT NULL DEFAULT 0 COMMENT '模型版本',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '数据版本',
  `data` text DEFAULT NULL COMMENT '字段值',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `data_flag` int(11) NOT NULL DEFAULT 10 COMMENT '数据状态',
  `vip_level` int(11) NOT NULL DEFAULT 0 COMMENT '访问级别',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '提报单位',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `create_by` varchar(32) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) NOT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
  PRIMARY KEY (`uid`),
  KEY `ida_gys0001_pid_v` (`pid`),
  KEY `ida_gys0001_mid_v` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据A字段值';

-- ----------------------------
-- Records of dma_gys0001_val
-- ----------------------------
BEGIN;
INSERT INTO `dma_gys0001_val` (`uid`, `pid`, `mid`, `mvs`, `version`, `data`, `remark`, `data_flag`, `vip_level`, `dept_id`, `tenant_id`, `create_by`, `create_time`, `update_by`, `update_time`, `revision`) VALUES (1890741108959744000, NULL, NULL, 0, 0, '{\"sys4\":{\"vv\":\"11\"},\"sys83\":{\"vv\":\"11\"},\"h001\":{\"vv\":\"11\"},\"h002\":{\"vv\":\"11\"},\"sys82\":{\"vv\":\"1\"},\"sys81\":{\"vv\":\"1\"}}', NULL, 10, 1, NULL, NULL, '1', '2025-02-15 20:33:03', '1', '2025-02-15 20:33:03', 0);
COMMIT;

-- ----------------------------
-- Table structure for dmb_gys0001_idx
-- ----------------------------
DROP TABLE IF EXISTS `dmb_gys0001_idx`;
CREATE TABLE `dmb_gys0001_idx` (
  `uid` bigint(20) NOT NULL COMMENT '主键ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID;层级模型',
  `mid` bigint(20) DEFAULT NULL COMMENT '主线ID;扩展模型',
  `mco` varchar(100) DEFAULT NULL COMMENT '主编码;右模糊查询',
  `lco` varchar(100) DEFAULT NULL COMMENT '层级编码;右模糊查询',
  `type_src` varchar(10) DEFAULT NULL COMMENT '来源类型;0界面 1导入 2接口 3ETL 4其他',
  `data_flag` int(11) NOT NULL DEFAULT 10 COMMENT '数据状态',
  `mvs` int(11) NOT NULL DEFAULT 0 COMMENT '模型版本',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '数据版本',
  `c01` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c02` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c03` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c04` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c05` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c06` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c07` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c08` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c09` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c10` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c11` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c12` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c13` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c14` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c15` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `n01` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n02` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n03` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n04` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n05` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `d01` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d02` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d03` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d04` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d05` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `vip_level` int(11) NOT NULL DEFAULT 0 COMMENT '访问级别',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '提报单位',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `create_by` varchar(32) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) NOT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
  PRIMARY KEY (`uid`),
  KEY `idb_gys0001_code_mas` (`mco`),
  KEY `idb_gys0001_code_cat` (`lco`),
  KEY `idb_gys0001_pid` (`pid`),
  KEY `idb_gys0001_mid` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据A索引表';

-- ----------------------------
-- Records of dmb_gys0001_idx
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for dmb_gys0001_val
-- ----------------------------
DROP TABLE IF EXISTS `dmb_gys0001_val`;
CREATE TABLE `dmb_gys0001_val` (
  `uid` bigint(20) NOT NULL COMMENT '主键ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID;层级模型',
  `mid` bigint(20) DEFAULT NULL COMMENT '主线ID;扩展模型',
  `mvs` int(11) NOT NULL DEFAULT 0 COMMENT '模型版本',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '数据版本',
  `data` text DEFAULT NULL COMMENT '字段值',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `data_flag` int(11) NOT NULL DEFAULT 10 COMMENT '数据状态',
  `vip_level` int(11) NOT NULL DEFAULT 0 COMMENT '访问级别',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '提报单位',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `create_by` varchar(32) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) NOT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
  PRIMARY KEY (`uid`),
  KEY `idb_gys0001_pid_v` (`pid`),
  KEY `idb_gys0001_mid_v` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据A字段值';

-- ----------------------------
-- Records of dmb_gys0001_val
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for dmc_gys0001_idx
-- ----------------------------
DROP TABLE IF EXISTS `dmc_gys0001_idx`;
CREATE TABLE `dmc_gys0001_idx` (
  `uid` bigint(20) NOT NULL COMMENT '主键ID',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '数据版本',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID;层级模型',
  `mid` bigint(20) DEFAULT NULL COMMENT '主线ID;扩展模型',
  `mco` varchar(100) DEFAULT NULL COMMENT '主编码;右模糊查询',
  `lco` varchar(100) DEFAULT NULL COMMENT '层级编码;右模糊查询',
  `type_src` varchar(10) DEFAULT NULL COMMENT '来源类型;0界面 1导入 2接口 3ETL 4其他',
  `data_flag` int(11) NOT NULL DEFAULT 10 COMMENT '数据状态',
  `mvs` int(11) NOT NULL DEFAULT 0 COMMENT '模型版本',
  `c01` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c02` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c03` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c04` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c05` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c06` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c07` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c08` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c09` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c10` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c11` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c12` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c13` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c14` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `c15` varchar(100) DEFAULT NULL COMMENT '字符01;动态字符索引',
  `n01` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n02` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n03` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n04` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `n05` decimal(18,6) DEFAULT NULL COMMENT '数字01;动态数字索引',
  `d01` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d02` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d03` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d04` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `d05` datetime DEFAULT NULL COMMENT '日期01;动态日期索引',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `vip_level` int(11) NOT NULL DEFAULT 0 COMMENT '访问级别',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '提报单位',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `create_by` varchar(32) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) NOT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
  PRIMARY KEY (`uid`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据C索引表';

-- ----------------------------
-- Records of dmc_gys0001_idx
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for dmc_gys0001_val
-- ----------------------------
DROP TABLE IF EXISTS `dmc_gys0001_val`;
CREATE TABLE `dmc_gys0001_val` (
  `uid` bigint(20) NOT NULL COMMENT '主键ID',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '数据版本',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID;层级模型',
  `mid` bigint(20) DEFAULT NULL COMMENT '主线ID;扩展模型',
  `mvs` int(11) NOT NULL DEFAULT 0 COMMENT '模型版本',
  `data` text DEFAULT NULL COMMENT '字段值',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `data_flag` int(11) NOT NULL DEFAULT 10 COMMENT '数据状态',
  `vip_level` int(11) NOT NULL DEFAULT 0 COMMENT '访问级别',
  `dept_id` varchar(32) DEFAULT NULL COMMENT '提报单位',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '租户号',
  `create_by` varchar(32) NOT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) NOT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `revision` int(11) NOT NULL DEFAULT 0 COMMENT '乐观锁',
  PRIMARY KEY (`uid`,`version`),
  KEY `idc_gys0001_pid_v` (`pid`),
  KEY `idc_gys0001_mid_v` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据C字段值';

-- ----------------------------
-- Records of dmc_gys0001_val
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for dta_model
-- ----------------------------
DROP TABLE IF EXISTS `dta_model`;
CREATE TABLE `dta_model` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '类型;数据字典sys_def_type',
  `area_code` varchar(20) NOT NULL COMMENT '主题编码',
  `slave_sw` varchar(10) DEFAULT NULL COMMENT '扩展标记',
  `classify_sw` varchar(10) DEFAULT NULL COMMENT '支持分类',
  `class_prop_sw` varchar(10) DEFAULT NULL COMMENT '属性模板',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;主分类，主模型',
  `audit_flag` int(11) DEFAULT 0 COMMENT '审核标记',
  `reject_flag` int(11) DEFAULT 0 COMMENT '回退标记',
  `state_json` varchar(2000) DEFAULT NULL COMMENT '状态JSON',
  `menu_json` varchar(2000) DEFAULT NULL COMMENT '环节JSON',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `idx_model_code` (`code`),
  KEY `idx_model_acode` (`area_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据模型A';

-- ----------------------------
-- Records of dta_model
-- ----------------------------
BEGIN;
INSERT INTO `dta_model` (`uid`, `code`, `name`, `data_type`, `area_code`, `slave_sw`, `classify_sw`, `class_prop_sw`, `link_code`, `audit_flag`, `reject_flag`, `state_json`, `menu_json`, `swt_json`, `ext_json`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('M1867818439372955648', 'TPL0000', '模板模型0000', 'A', 'TEST01', '0', '0', '0', '', 1, 0, NULL, NULL, NULL, NULL, 0, 0, 'admin', '2024-12-14 14:26:32', NULL, NULL, NULL, '模板模型调整');
INSERT INTO `dta_model` (`uid`, `code`, `name`, `data_type`, `area_code`, `slave_sw`, `classify_sw`, `class_prop_sw`, `link_code`, `audit_flag`, `reject_flag`, `state_json`, `menu_json`, `swt_json`, `ext_json`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('M1867898642543620096', 'GYS0001', '供应商0001', 'A', 'TEST01', '0', '0', '0', NULL, 4, 0, NULL, NULL, NULL, NULL, 0, 0, 'admin', '2024-12-14 19:45:14', 'admin', '2025-02-15 20:25:47', NULL, '供应商也可以是厂商');
COMMIT;

-- ----------------------------
-- Table structure for dta_prop
-- ----------------------------
DROP TABLE IF EXISTS `dta_prop`;
CREATE TABLE `dta_prop` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `model_code` varchar(20) NOT NULL COMMENT '模型编码',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '数据类型;数据字典prop_data_type',
  `view_type` varchar(10) NOT NULL COMMENT '展示类型;数据字典prop_view_type',
  `src_type` varchar(10) NOT NULL COMMENT '来源类型;数据字典prop_source_type',
  `quick_sw` varchar(10) DEFAULT '0' COMMENT '快捷搜索',
  `advance_sw` varchar(10) DEFAULT '0' COMMENT '高级搜索',
  `view_sw` varchar(10) DEFAULT '0' COMMENT '列表显示',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;数据来源模型',
  `hide_code` varchar(20) DEFAULT NULL COMMENT '隐藏编码',
  `col_code` varchar(20) DEFAULT NULL COMMENT '索引字段;数据库字段，查询使用',
  `col_num` int(11) DEFAULT 50 COMMENT '显示排序',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `edit_flag` int(11) DEFAULT 0 COMMENT '修改标记;0新增1变更2内置4停用',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  KEY `idx_prop_mcode` (`model_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据属性A';

-- ----------------------------
-- Records of dta_prop
-- ----------------------------
BEGIN;
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105152708608', 'TPL0000', 'uid', '主键ID', 'B', 'B0', '0', '0', '0', '0', NULL, NULL, NULL, 1, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, 0, 'admin', '2024-12-14 14:41:06', 'admin', '2024-12-14 14:41:30', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105169485824', 'TPL0000', 'pid', '上级ID', 'B', 'B0', '0', '0', '0', '0', NULL, NULL, NULL, 2, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":20}', 3, 0, 0, 'admin', '2024-12-14 14:41:06', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105186263040', 'TPL0000', 'mid', '主线ID', 'B', 'B0', '0', '0', '0', '0', NULL, NULL, NULL, 3, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, 0, 'admin', '2024-12-14 14:41:06', 'admin', '2024-12-14 14:41:39', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105198845952', 'TPL0000', 'mco', '主编码', 'A', 'A1', '1', '1', '0', '1', NULL, NULL, NULL, 4, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 1, 0, 0, 'admin', '2024-12-14 14:41:06', 'admin', '2024-12-14 14:49:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105215623168', 'TPL0000', 'cco', '分类编码', 'A', 'X1', '0', '1', '1', '1', NULL, NULL, NULL, 5, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 3, 0, 0, 'admin', '2024-12-14 14:41:06', 'admin', '2024-12-14 14:57:47', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105215623170', 'TPL0000', 'lco', '层级编码', 'A', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 6, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":100}', 3, 0, 0, 'admin', '2024-12-14 14:41:06', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105232400384', 'TPL0000', 'type_src', '来源类型', 'A', 'X1', '0', '0', '0', '1', NULL, NULL, NULL, 7, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":10}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 14:58:09', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105244983296', 'TPL0000', 'task_id', '任务ID', 'A', 'X1', '0', '0', '0', '1', NULL, NULL, NULL, 99, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 14:58:32', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105261760512', 'TPL0000', 'task_state', '任务运行态', 'B', 'B0', '0', '0', '0', '1', NULL, NULL, NULL, 99, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 14:58:41', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105278537728', 'TPL0000', 'mvs', '模型版本', 'B', 'B0', '0', '0', '0', '1', NULL, NULL, NULL, 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 14:58:49', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105341452288', 'TPL0000', 'remark', '备注', 'A', 'A1', '1', '0', '1', '0', NULL, NULL, NULL, 91, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":300}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 16:04:24', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105354035200', 'TPL0000', 'vip_level', '访问级别', 'B', 'B0', '0', '0', '0', '0', NULL, NULL, NULL, 92, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 16:05:10', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105370812416', 'TPL0000', 'dept_id', '归属单位', 'A', 'X1', '0', '0', '0', '1', NULL, NULL, NULL, 93, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":32}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', 'admin', '2024-12-14 14:59:10', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105387589632', 'TPL0000', 'tenant_id', '租户号', 'A', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 94, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105404366848', 'TPL0000', 'create_by', '创建人', 'A', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 95, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105421144064', 'TPL0000', 'create_time', '创建时间', 'C', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 96, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105437921280', 'TPL0000', 'update_by', '更新人', 'A', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 97, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105454698496', 'TPL0000', 'update_time', '更新时间', 'C', 'X1', '0', '0', '0', '0', NULL, NULL, NULL, 98, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867822105471475712', 'TPL0000', 'revision', '乐观锁', 'B', 'B0', '0', '0', '0', '0', NULL, NULL, NULL, 99, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, 0, 'admin', '2024-12-14 14:41:07', NULL, NULL, NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642614923264', 'GYS0001', 'uid', '主键ID', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys1', 'uid', 1, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642631700480', 'GYS0001', 'pid', '上级ID', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys2', 'pid', 2, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642640089088', 'GYS0001', 'mid', '主线ID', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys3', 'mid', 3, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642652672000', 'GYS0001', 'mco', '厂商编码', 'A', 'A1', '1', '1', '1', '1', NULL, 'sys4', 'mco', 4, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 1, 0, 0, 'admin', '2024-12-14 19:45:14', 'admin', '2024-12-14 20:44:25', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642677837824', 'GYS0001', 'lco', '层级编码', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys6', 'lco', 6, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":100}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642694615040', 'GYS0001', 'type_src', '来源类型', 'A', 'X2', '0', '0', '0', '1', NULL, 'sys7', 'type_src', 7, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":10}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642707197952', 'GYS0001', 'mvs', '模型版本', 'B', 'X2', '0', '0', '0', '1', NULL, 'sys80', 'mvs', 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642719780864', 'GYS0001', 'remark', '备注', 'A', 'A1', '1', '0', '1', '0', NULL, 'sys81', 'remark', 81, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":300}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642728169472', 'GYS0001', 'vip_level', '访问级别', 'B', 'B0', '0', '0', '0', '1', NULL, 'sys82', 'vip_level', 82, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642740752384', 'GYS0001', 'dept_id', '归属单位', 'A', 'X1', '0', '0', '0', '1', NULL, 'sys83', 'dept_id', 83, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642749140992', 'GYS0001', 'tenant_id', '租户号', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys84', 'tenant_id', 84, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642757529600', 'GYS0001', 'create_by', '创建人', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys85', 'create_by', 85, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642765918208', 'GYS0001', 'create_time', '创建时间', 'C', 'X2', '0', '0', '0', '0', NULL, 'sys86', 'create_time', 86, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642774306816', 'GYS0001', 'update_by', '更新人', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys87', 'update_by', 87, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642782695424', 'GYS0001', 'update_time', '更新时间', 'C', 'X2', '0', '0', '0', '0', NULL, 'sys88', 'update_time', 88, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642791084032', 'GYS0001', 'task_id', '任务ID', 'A', 'X2', '0', '0', '0', '1', NULL, 'sys89', 'task_id', 89, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642799472640', 'GYS0001', 'task_state', '任务运行态', 'B', 'X2', '0', '0', '0', '1', NULL, 'sys90', 'task_state', 90, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642803666944', 'GYS0001', 'revision', '乐观锁', 'B', 'B0', '0', '0', '0', '0', NULL, 'sys91', 'revision', 91, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867913487217274880', 'GYS0001', 'csmc', '厂商名称', 'A', 'A1', '1', '1', '1', '1', NULL, 'h001', 'c01', 11, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 0, 0, 0, 'admin', '2024-12-14 20:44:14', 'admin', '2024-12-14 20:56:07', NULL, NULL);
INSERT INTO `dta_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867916296784392192', 'GYS0001', 'tyshxydm', '统一社会信用代码', 'A', 'A1', '1', '1', '1', '1', NULL, 'h002', 'c02', 20, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 0, 0, 0, 'admin', '2024-12-14 20:55:24', 'admin', '2024-12-14 20:55:58', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for dta_tpl_prop
-- ----------------------------
DROP TABLE IF EXISTS `dta_tpl_prop`;
CREATE TABLE `dta_tpl_prop` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `model_code` varchar(20) NOT NULL COMMENT '模型编码',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '数据类型;数据字典prop_data_type',
  `view_type` varchar(10) NOT NULL COMMENT '展示类型;数据字典prop_view_type',
  `src_type` varchar(10) NOT NULL COMMENT '来源类型;数据字典prop_source_type',
  `quick_sw` varchar(10) DEFAULT '0' COMMENT '快捷搜索',
  `advance_sw` varchar(10) DEFAULT '0' COMMENT '高级搜索',
  `view_sw` varchar(10) DEFAULT '0' COMMENT '列表显示',
  `hide_code` varchar(20) DEFAULT NULL COMMENT '隐藏编码',
  `col_code` varchar(20) DEFAULT NULL COMMENT '索引字段;数据库字段，查询使用',
  `col_num` int(11) DEFAULT 50 COMMENT '显示排序',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `edit_flag` int(11) DEFAULT 0 COMMENT '修改标记;0新增1变更2内置4停用',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据属性A';

-- ----------------------------
-- Records of dta_tpl_prop
-- ----------------------------
BEGIN;
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys1', 'TPL0000', 'uid', '主键ID', 'B', 'X2', '0', '0', '0', '0', 'sys1', 'uid', 1, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys2', 'TPL0000', 'pid', '上级ID', 'B', 'X2', '0', '0', '0', '0', 'sys2', 'pid', 2, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":20}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys3', 'TPL0000', 'mid', '主线ID', 'B', 'X2', '0', '0', '0', '0', 'sys3', 'mid', 3, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys4', 'TPL0000', 'mco', '主编码', 'A', 'A1', '1', '1', '0', '1', 'sys4', 'mco', 4, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 1, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys5', 'TPL0000', 'cco', '分类编码', 'A', 'X1', '0', '1', '1', '1', 'sys5', 'cco', 5, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys6', 'TPL0000', 'lco', '层级编码', 'A', 'X2', '0', '0', '0', '0', 'sys6', 'lco', 6, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":100}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys7', 'TPL0000', 'type_src', '来源类型', 'A', 'X2', '0', '0', '0', '1', 'sys7', 'type_src', 7, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":10}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys80', 'TPL0000', 'mvs', '模型版本', 'B', 'X2', '0', '0', '0', '1', 'sys80', 'mvs', 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys81', 'TPL0000', 'remark', '备注', 'A', 'A1', '1', '0', '1', '0', 'sys81', 'remark', 81, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":300}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys82', 'TPL0000', 'vip_level', '访问级别', 'B', 'B0', '0', '0', '0', '0', 'sys82', 'vip_level', 82, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys83', 'TPL0000', 'dept_id', '归属单位', 'A', 'X1', '0', '0', '0', '1', 'sys83', 'dept_id', 83, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys84', 'TPL0000', 'tenant_id', '租户号', 'A', 'X2', '0', '0', '0', '0', 'sys84', 'tenant_id', 84, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys85', 'TPL0000', 'create_by', '创建人', 'A', 'X2', '0', '0', '0', '0', 'sys85', 'create_by', 85, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys86', 'TPL0000', 'create_time', '创建时间', 'C', 'X2', '0', '0', '0', '0', 'sys86', 'create_time', 86, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys87', 'TPL0000', 'update_by', '更新人', 'A', 'X2', '0', '0', '0', '0', 'sys87', 'update_by', 87, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys88', 'TPL0000', 'update_time', '更新时间', 'C', 'X2', '0', '0', '0', '0', 'sys88', 'update_time', 88, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys89', 'TPL0000', 'task_id', '任务ID', 'A', 'X2', '0', '0', '0', '1', 'sys89', 'task_id', 89, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys90', 'TPL0000', 'task_state', '任务运行态', 'B', 'X2', '0', '0', '0', '1', 'sys90', 'task_state', 90, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0);
INSERT INTO `dta_tpl_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`) VALUES ('sys91', 'TPL0000', 'revision', '乐观锁', 'B', 'X2', '0', '0', '0', '0', 'sys91', 'revision', 91, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0);
COMMIT;

-- ----------------------------
-- Table structure for dtb_area
-- ----------------------------
DROP TABLE IF EXISTS `dtb_area`;
CREATE TABLE `dtb_area` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `parent_id` varchar(32) DEFAULT 'NULL' COMMENT '父级ID',
  `ancestors` varchar(500) DEFAULT 'NULL' COMMENT '祖级列表',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT 'NULL' COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT 'NULL' COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT 'NULL' COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT 'NULL' COMMENT '备注',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='资产主题';

-- ----------------------------
-- Records of dtb_area
-- ----------------------------
BEGIN;
INSERT INTO `dtb_area` (`uid`, `parent_id`, `ancestors`, `code`, `name`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('A1865732013262823424', 'NULL', 'NULL', 'TEST01', '测试主题', 0, 'admin', '2024-12-08 20:15:50', 'NULL', NULL, 'NULL', 'NULL');
COMMIT;

-- ----------------------------
-- Table structure for dtb_model
-- ----------------------------
DROP TABLE IF EXISTS `dtb_model`;
CREATE TABLE `dtb_model` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '类型;数据字典sys_def_type',
  `area_code` varchar(20) NOT NULL COMMENT '主题编码',
  `slave_sw` varchar(10) DEFAULT NULL COMMENT '扩展标记',
  `classify_sw` varchar(10) DEFAULT NULL COMMENT '支持分类',
  `class_prop_sw` varchar(10) DEFAULT NULL COMMENT '属性模板',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;主分类，主模型',
  `audit_flag` int(11) DEFAULT 0 COMMENT '审核标记',
  `reject_flag` int(11) DEFAULT 0 COMMENT '回退标记',
  `state_json` varchar(2000) DEFAULT NULL COMMENT '状态JSON',
  `menu_json` varchar(2000) DEFAULT NULL COMMENT '环节JSON',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  `vip_level` int(11) DEFAULT NULL COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据模型B';

-- ----------------------------
-- Records of dtb_model
-- ----------------------------
BEGIN;
INSERT INTO `dtb_model` (`uid`, `code`, `name`, `data_type`, `area_code`, `slave_sw`, `classify_sw`, `class_prop_sw`, `link_code`, `audit_flag`, `reject_flag`, `state_json`, `menu_json`, `swt_json`, `ext_json`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('M1867898642543620096', 'GYS0001', '供应商0001', 'A', 'TEST01', '0', '0', '0', NULL, 4, 0, NULL, NULL, NULL, NULL, 0, 0, 'admin', '2024-12-14 19:45:14', 'admin', '2025-02-15 20:25:47', NULL, '供应商也可以是厂商');
COMMIT;

-- ----------------------------
-- Table structure for dtb_prop
-- ----------------------------
DROP TABLE IF EXISTS `dtb_prop`;
CREATE TABLE `dtb_prop` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `model_code` varchar(20) NOT NULL COMMENT '模型编码',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '数据类型;数据字典prop_data_type',
  `view_type` varchar(10) NOT NULL COMMENT '展示类型;数据字典prop_view_type',
  `src_type` varchar(10) NOT NULL COMMENT '来源类型;数据字典prop_source_type',
  `quick_sw` varchar(10) DEFAULT '0' COMMENT '快捷搜索',
  `advance_sw` varchar(10) DEFAULT '0' COMMENT '高级搜索',
  `view_sw` varchar(10) DEFAULT '0' COMMENT '列表显示',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;数据来源模型',
  `hide_code` varchar(20) DEFAULT NULL COMMENT '隐藏编码',
  `col_code` varchar(20) DEFAULT NULL COMMENT '索引字段;数据库字段，查询使用',
  `col_num` int(11) DEFAULT 50 COMMENT '显示排序',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `edit_flag` int(11) DEFAULT 0 COMMENT '修改标记;0新增1变更2内置4停用',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  `vip_level` int(11) DEFAULT 0 COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`),
  KEY `idx_propb_mcode` (`model_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据属性B';

-- ----------------------------
-- Records of dtb_prop
-- ----------------------------
BEGIN;
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642614923264', 'GYS0001', 'uid', '主键ID', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys1', 'uid', 1, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642631700480', 'GYS0001', 'pid', '上级ID', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys2', 'pid', 2, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642640089088', 'GYS0001', 'mid', '主线ID', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys3', 'mid', 3, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642652672000', 'GYS0001', 'mco', '厂商编码', 'A', 'A1', '1', '1', '1', '1', NULL, 'sys4', 'mco', 4, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 1, 0, 0, 'admin', '2024-12-14 19:45:14', 'admin', '2024-12-14 20:44:25', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642677837824', 'GYS0001', 'lco', '层级编码', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys6', 'lco', 6, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":100}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642694615040', 'GYS0001', 'type_src', '来源类型', 'A', 'X2', '0', '0', '0', '1', NULL, 'sys7', 'type_src', 7, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":10}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642707197952', 'GYS0001', 'mvs', '模型版本', 'B', 'X2', '0', '0', '0', '1', NULL, 'sys80', 'mvs', 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642719780864', 'GYS0001', 'remark', '备注', 'A', 'A1', '1', '0', '1', '0', NULL, 'sys81', 'remark', 81, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":300}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642728169472', 'GYS0001', 'vip_level', '访问级别', 'B', 'B0', '0', '0', '0', '1', NULL, 'sys82', 'vip_level', 82, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642740752384', 'GYS0001', 'dept_id', '归属单位', 'A', 'X1', '0', '0', '0', '1', NULL, 'sys83', 'dept_id', 83, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642749140992', 'GYS0001', 'tenant_id', '租户号', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys84', 'tenant_id', 84, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642757529600', 'GYS0001', 'create_by', '创建人', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys85', 'create_by', 85, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642765918208', 'GYS0001', 'create_time', '创建时间', 'C', 'X2', '0', '0', '0', '0', NULL, 'sys86', 'create_time', 86, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642774306816', 'GYS0001', 'update_by', '更新人', 'A', 'X2', '0', '0', '0', '0', NULL, 'sys87', 'update_by', 87, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642782695424', 'GYS0001', 'update_time', '更新时间', 'C', 'X2', '0', '0', '0', '0', NULL, 'sys88', 'update_time', 88, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642791084032', 'GYS0001', 'task_id', '任务ID', 'A', 'X2', '0', '0', '0', '1', NULL, 'sys89', 'task_id', 89, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642799472640', 'GYS0001', 'task_state', '任务运行态', 'B', 'X2', '0', '0', '0', '1', NULL, 'sys90', 'task_state', 90, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642803666944', 'GYS0001', 'revision', '乐观锁', 'B', 'X2', '0', '0', '0', '0', NULL, 'sys91', 'revision', 91, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867913487217274880', 'GYS0001', 'csmc', '厂商名称', 'A', 'A1', '1', '1', '1', '1', NULL, 'h001', 'c01', 11, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 0, 0, 0, 'admin', '2024-12-14 20:44:14', 'admin', '2024-12-14 20:56:07', NULL, NULL);
INSERT INTO `dtb_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867916296784392192', 'GYS0001', 'tyshxydm', '统一社会信用代码', 'A', 'A1', '1', '1', '1', '1', NULL, 'h002', 'c02', 20, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 0, 0, 0, 'admin', '2024-12-14 20:55:24', 'admin', '2024-12-14 20:55:58', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for dtc_model
-- ----------------------------
DROP TABLE IF EXISTS `dtc_model`;
CREATE TABLE `dtc_model` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '类型;数据字典sys_def_type',
  `area_code` varchar(20) NOT NULL COMMENT '主题编码',
  `slave_sw` varchar(10) DEFAULT NULL COMMENT '扩展标记',
  `classify_sw` varchar(10) DEFAULT NULL COMMENT '支持分类',
  `class_prop_sw` varchar(10) DEFAULT NULL COMMENT '属性模板',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;主分类，主模型',
  `audit_flag` int(11) DEFAULT 0 COMMENT '审核标记',
  `reject_flag` int(11) DEFAULT 0 COMMENT '回退标记',
  `state_json` varchar(2000) DEFAULT NULL COMMENT '状态JSON',
  `menu_json` varchar(2000) DEFAULT NULL COMMENT '环节JSON',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `version` int(11) NOT NULL COMMENT '版本号',
  `vip_level` int(11) DEFAULT 0 COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据模型C';

-- ----------------------------
-- Records of dtc_model
-- ----------------------------
BEGIN;
INSERT INTO `dtc_model` (`uid`, `code`, `name`, `data_type`, `area_code`, `slave_sw`, `classify_sw`, `class_prop_sw`, `link_code`, `audit_flag`, `reject_flag`, `state_json`, `menu_json`, `swt_json`, `ext_json`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('M1867898642543620096', 'GYS0001', '供应商0001', 'A', 'TEST01', '0', '0', '0', NULL, 4, 0, NULL, NULL, NULL, NULL, 0, 0, 'admin', '2024-12-14 19:45:14', 'admin', '2025-02-15 20:25:47', NULL, '供应商也可以是厂商');
COMMIT;

-- ----------------------------
-- Table structure for dtc_prop
-- ----------------------------
DROP TABLE IF EXISTS `dtc_prop`;
CREATE TABLE `dtc_prop` (
  `uid` varchar(32) NOT NULL COMMENT '主键ID',
  `model_code` varchar(20) NOT NULL COMMENT '模型编码',
  `code` varchar(20) NOT NULL COMMENT '编码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `data_type` varchar(10) NOT NULL COMMENT '数据类型;数据字典prop_data_type',
  `view_type` varchar(10) NOT NULL COMMENT '展示类型;数据字典prop_view_type',
  `src_type` varchar(10) NOT NULL COMMENT '来源类型;数据字典prop_source_type',
  `quick_sw` varchar(10) DEFAULT '0' COMMENT '快捷搜索',
  `advance_sw` varchar(10) DEFAULT '0' COMMENT '高级搜索',
  `view_sw` varchar(10) DEFAULT '0' COMMENT '列表显示',
  `link_code` varchar(20) DEFAULT NULL COMMENT '引用编码;数据来源模型',
  `hide_code` varchar(20) DEFAULT NULL COMMENT '隐藏编码',
  `col_code` varchar(20) DEFAULT NULL COMMENT '索引字段;数据库字段，查询使用',
  `col_num` int(11) DEFAULT 50 COMMENT '显示排序',
  `swt_json` varchar(2000) DEFAULT NULL COMMENT '开关JSON',
  `ext_json` varchar(2000) DEFAULT NULL COMMENT '扩展JSON',
  `edit_flag` int(11) DEFAULT 0 COMMENT '修改标记;0新增1变更2内置4停用',
  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',
  `vip_level` int(11) DEFAULT 0 COMMENT 'VIP级别',
  `create_by` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `tenant_id` varchar(32) DEFAULT NULL COMMENT '分公司ID',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`uid`,`version`),
  KEY `idx_propc_mcode` (`model_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='数据属性C';

-- ----------------------------
-- Records of dtc_prop
-- ----------------------------
BEGIN;
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642614923264', 'GYS0001', 'uid', '主键ID', 'B', 'B0', '0', '0', '0', '0', NULL, 'sys1', 'uid', 1, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642631700480', 'GYS0001', 'pid', '上级ID', 'B', 'B0', '0', '0', '0', '0', NULL, 'sys2', 'pid', 2, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642640089088', 'GYS0001', 'mid', '主线ID', 'B', 'B0', '0', '0', '0', '0', NULL, 'sys3', 'mid', 3, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":20}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642652672000', 'GYS0001', 'mco', '厂商编码', 'A', 'A1', '1', '1', '1', '1', NULL, 'sys4', 'mco', 4, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 1, 0, 0, 'admin', '2024-12-14 19:45:14', 'admin', '2024-12-14 20:44:25', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642677837824', 'GYS0001', 'lco', '层级编码', 'A', 'X1', '0', '0', '0', '0', NULL, 'sys6', 'lco', 6, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":100}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642694615040', 'GYS0001', 'type_src', '来源类型', 'A', 'X1', '0', '0', '0', '1', NULL, 'sys7', 'type_src', 7, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":10}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642707197952', 'GYS0001', 'mvs', '模型版本', 'B', 'B0', '0', '0', '0', '1', NULL, 'sys80', 'mvs', 80, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642719780864', 'GYS0001', 'remark', '备注', 'A', 'A1', '1', '0', '1', '0', NULL, 'sys81', 'remark', 81, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":300}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642728169472', 'GYS0001', 'vip_level', '访问级别', 'B', 'B0', '0', '0', '0', '1', NULL, 'sys82', 'vip_level', 82, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642740752384', 'GYS0001', 'dept_id', '归属单位', 'A', 'X1', '0', '0', '0', '1', NULL, 'sys83', 'dept_id', 83, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642749140992', 'GYS0001', 'tenant_id', '租户号', 'A', 'X1', '0', '0', '0', '0', NULL, 'sys84', 'tenant_id', 84, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642757529600', 'GYS0001', 'create_by', '创建人', 'A', 'X1', '0', '0', '0', '0', NULL, 'sys85', 'create_by', 85, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642765918208', 'GYS0001', 'create_time', '创建时间', 'C', 'X1', '0', '0', '0', '0', NULL, 'sys86', 'create_time', 86, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642774306816', 'GYS0001', 'update_by', '更新人', 'A', 'X1', '0', '0', '0', '0', NULL, 'sys87', 'update_by', 87, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\",\"maxLen\":32}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642782695424', 'GYS0001', 'update_time', '更新时间', 'C', 'X1', '0', '0', '0', '0', NULL, 'sys88', 'update_time', 88, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642791084032', 'GYS0001', 'task_id', '任务ID', 'A', 'X1', '0', '0', '0', '1', NULL, 'sys89', 'task_id', 89, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642799472640', 'GYS0001', 'task_state', '任务运行态', 'B', 'B0', '0', '0', '0', '1', NULL, 'sys90', 'task_state', 90, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"decLen\":0,\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867898642803666944', 'GYS0001', 'revision', '乐观锁', 'B', 'B0', '0', '0', '0', '0', NULL, 'sys91', 'revision', 91, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"searchType\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"decLen\":0,\"prefixType\":\"0\",\"notNvl\":\"0\"}', 3, 0, NULL, 'admin', '2024-12-14 19:45:14', NULL, '2024-12-14 19:45:14', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867913487217274880', 'GYS0001', 'csmc', '厂商名称', 'A', 'A1', '1', '1', '1', '1', NULL, 'h001', 'c01', 11, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"1\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":100}', 0, 0, 0, 'admin', '2024-12-14 20:44:14', 'admin', '2024-12-14 20:56:07', NULL, NULL);
INSERT INTO `dtc_prop` (`uid`, `model_code`, `code`, `name`, `data_type`, `view_type`, `src_type`, `quick_sw`, `advance_sw`, `view_sw`, `link_code`, `hide_code`, `col_code`, `col_num`, `swt_json`, `ext_json`, `edit_flag`, `version`, `vip_level`, `create_by`, `create_time`, `update_by`, `update_time`, `tenant_id`, `remark`) VALUES ('P1867916296784392192', 'GYS0001', 'tyshxydm', '统一社会信用代码', 'A', 'A1', '1', '1', '1', '1', NULL, 'h002', 'c02', 20, '{\"fullSw\":\"0\",\"shortSw\":\"0\",\"longSw\":\"0\"}', '{\"prefixType\":\"0\",\"searchType\":\"0\",\"notNvl\":\"0\",\"suffixType\":\"0\",\"defaultType\":\"0\",\"maxLen\":50}', 0, 0, 0, 'admin', '2024-12-14 20:55:24', 'admin', '2024-12-14 20:55:58', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-07 09:10:10', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-03-04 13:38:13', '', NULL, '初始化密码 123456');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-03-04 13:38:13', '', NULL, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '账号自助-验证码开关', 'sys.account.captchaOnOff', 'false', 'Y', 'admin', '2022-03-04 13:38:13', 'admin', '2023-07-13 09:35:43', '是否开启验证码功能（true开启，false关闭）');
INSERT INTO `sys_config` (`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-03-04 13:38:13', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parent_id` bigint(20) DEFAULT 0 COMMENT '父部门id',
  `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `order_num` int(4) DEFAULT 0 COMMENT '显示顺序',
  `leader` varchar(20) DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (100, 0, '0', '小瓜科技', 0, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-07 10:47:30');
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (101, 100, '0,100', '深圳总公司', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (102, 100, '0,100', '长沙分公司', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (103, 101, '0,100,101', '研发部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (104, 101, '0,100,101', '市场部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (105, 101, '0,100,101', '测试部门', 3, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (106, 101, '0,100,101', '财务部门', 4, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (107, 101, '0,100,101', '运维部门', 5, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (108, 102, '0,100,102', '市场部门', 1, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
INSERT INTO `sys_dept` (`dept_id`, `parent_id`, `ancestors`, `dept_name`, `order_num`, `leader`, `phone`, `email`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (109, 102, '0,100,102', '财务部门', 2, '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT 0 COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '性别男');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '性别女');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '性别未知');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '显示菜单');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '隐藏菜单');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '默认分组');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统分组');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统默认是');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统默认否');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '通知');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '公告');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '关闭状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '新增操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '修改操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '删除操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '授权操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '导出操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '导入操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '强退操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '生成操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '清空操作');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '正常状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '停用状态');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (100, 1, '普通列表', 'A', 'sys_def_type', NULL, 'info', 'N', '0', 'admin', '2022-03-07 09:14:40', 'admin', '2022-03-17 10:58:17', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101, 2, '普通层级', 'B', 'sys_def_type', NULL, 'primary', 'N', '0', 'admin', '2022-03-07 09:15:31', 'admin', '2022-03-17 10:58:27', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (104, 3, '唯一扩展', 'C', 'sys_def_type', NULL, 'warning', 'N', '0', 'admin', '2022-03-07 09:23:43', 'admin', '2022-03-17 10:59:27', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (105, 1, 'VIP1', '1', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:19:05', 'admin', '2022-03-08 10:19:31', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (106, 2, 'VIP2', '2', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:19:26', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (107, 3, 'VIP3', '3', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:19:41', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (108, 4, 'VIP4', '4', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:20:01', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (109, 5, '绿区用户', '5', 'sys_user_vip', NULL, 'success', 'N', '0', 'admin', '2022-03-08 10:21:13', 'admin', '2022-03-08 10:22:24', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (110, 6, '黄区用户', '6', 'sys_user_vip', NULL, 'warning', 'N', '0', 'admin', '2022-03-08 10:21:37', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (111, 9, '红区用户', '9', 'sys_user_vip', NULL, 'danger', 'N', '0', 'admin', '2022-03-08 10:22:08', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (112, 0, '默认级别', '0', 'sys_user_vip', NULL, 'default', 'N', '0', 'admin', '2022-03-08 10:36:37', 'admin', '2022-03-15 11:06:46', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (113, 4, '多值扩展', 'D', 'sys_def_type', NULL, 'warning', 'N', '0', 'admin', '2022-03-17 10:59:19', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (114, 1, '否', '0', 'sys_def_switch', NULL, 'warning', 'N', '0', 'admin', '2022-03-23 15:08:59', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (115, 2, '是', '1', 'sys_def_switch', NULL, 'primary', 'N', '0', 'admin', '2022-03-23 15:09:14', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (116, 0, '字符', 'A', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:20:55', 'admin', '2022-03-29 14:22:07', '字符串');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (117, 1, '数值', 'B', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:21:44', '', NULL, '整数、小数');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (118, 2, '日期', 'C', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:22:47', '', NULL, '日期、时间');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (119, 5, '文件', 'D', 'prop_data_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:24:33', 'admin', '2022-03-29 14:28:36', '大文本、图片');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (120, 0, '只读', 'X1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:32:03', 'admin', '2022-03-29 14:49:24', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (121, 12, '下拉选项', 'A2', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:32:36', 'admin', '2022-03-29 14:41:25', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (122, 18, '弹框选择', 'A8', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:32:59', 'admin', '2022-03-30 16:52:20', '配置引用模型');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (123, 34, '日期选择', 'C0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:33:19', 'admin', '2022-03-29 14:40:02', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (124, 35, '时间选择', 'C1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:33:57', 'admin', '2022-03-29 14:40:07', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (125, 36, '日期时间', 'C2', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:34:18', 'admin', '2022-03-29 14:40:11', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (126, 11, '文本框', 'A1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:35:24', 'admin', '2025-01-04 11:49:37', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (127, 13, '下拉搜索', 'A3', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:41:45', 'admin', '2022-03-30 16:52:15', '配置引用模型');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (128, 20, '整数输入', 'B0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:43:46', 'admin', '2022-03-29 14:43:54', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (129, 21, '小数输入', 'B1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:44:16', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (130, 40, '大文本', 'D0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:45:54', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (131, 41, '图片', 'D1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:46:29', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (132, 1, '手动输入', '1', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:51:11', 'admin', '2022-04-22 14:05:44', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (133, 2, '自定义', '2', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:52:29', 'admin', '2022-04-22 14:19:12', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (134, 3, '数据字典', '3', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:52:46', 'admin', '2022-04-22 14:19:19', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (135, 4, '引用模型', '4', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 14:53:06', 'admin', '2022-04-22 14:06:31', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (136, 50, '单选按钮', 'E0', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 15:07:15', 'admin', '2022-03-29 15:10:34', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (137, 51, '多选按钮', 'E1', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2022-03-29 15:07:50', 'admin', '2022-03-29 15:10:52', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (138, 0, '无需输入', '0', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-04-22 14:05:36', 'admin', '2022-04-22 14:07:45', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (140, 5, '编码规则', '5', 'prop_source_type', NULL, 'default', 'N', '0', 'admin', '2022-04-22 14:09:16', 'admin', '2022-04-22 14:14:55', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (141, 1, '隐藏', 'X2', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2025-01-04 11:33:47', 'admin', '2025-01-04 11:34:08', NULL);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (142, 14, '文本域', 'A4', 'prop_view_type', NULL, 'default', 'N', '0', 'admin', '2025-01-04 11:49:59', 'admin', '2025-01-04 11:50:25', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '用户性别列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '菜单状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统开关列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '任务状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '任务分组列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '系统是否列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '通知类型列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '通知状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '操作类型列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '登录状态列表');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (100, '数据定义类型', 'sys_def_type', '0', 'admin', '2022-03-07 09:13:00', 'admin', '2022-03-29 14:15:38', '模型的类型');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101, '数据访问级别', 'sys_user_vip', '0', 'admin', '2022-03-08 10:16:44', 'admin', '2022-03-29 14:16:20', '用户的会员级别，数据的访问级别');
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (102, '数据定义开关', 'sys_def_switch', '0', 'admin', '2022-03-23 15:07:11', 'admin', '2022-03-29 14:16:08', NULL);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (103, '属性数据类型', 'prop_data_type', '0', 'admin', '2022-03-29 14:15:10', '', NULL, NULL);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (104, '属性展示类型', 'prop_view_type', '0', 'admin', '2022-03-29 14:17:09', '', NULL, NULL);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (105, '属性来源类型', 'prop_source_type', '0', 'admin', '2022-03-29 14:18:38', 'admin', '2022-03-29 14:20:06', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
DROP TABLE IF EXISTS `sys_logininfor`;
CREATE TABLE `sys_logininfor` (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='系统访问记录';

-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT 0 COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT 0 COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) DEFAULT NULL COMMENT '路由参数',
  `is_frame` int(1) DEFAULT 1 COMMENT '是否为外链（0是 1否）',
  `is_cache` int(1) DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2012 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '系统管理', 0, 1, 'system', NULL, '', 1, 0, 'M', '0', '0', '', 'system', 'admin', '2022-03-04 13:38:13', '', NULL, '系统管理目录');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '若依官网*', 0, 4, 'http://ruoyi.vip', NULL, '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 15:03:38', '若依官网地址');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (100, '用户管理', 1, 1, 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:38:55', '用户管理菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101, '角色管理', 1, 2, 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:01', '角色管理菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (102, '菜单管理', 1, 3, 'menu', 'system/menu/index', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:07', '菜单管理菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (103, '部门管理', 1, 4, 'dept', 'system/dept/index', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:13', '部门管理菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (104, '岗位管理', 1, 5, 'post', 'system/post/index', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:19', '岗位管理菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (105, '字典管理', 1, 6, 'dict', 'system/dict/index', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:24', '字典管理菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (106, '参数设置', 1, 7, 'config', 'system/config/index', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-08 13:39:29', '参数设置菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (107, '通知公告', 1, 8, 'notice', 'system/notice/index', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', '2022-03-04 13:38:13', '', NULL, '通知公告菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1001, '用户查询', 100, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1002, '用户新增', 100, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1003, '用户修改', 100, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1004, '用户删除', 100, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1005, '用户导出', 100, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1006, '用户导入', 100, 6, '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1007, '重置密码', 100, 7, '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1008, '角色查询', 101, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1009, '角色新增', 101, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1010, '角色修改', 101, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1011, '角色删除', 101, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1012, '角色导出', 101, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1013, '菜单查询', 102, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1014, '菜单新增', 102, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1015, '菜单修改', 102, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1016, '菜单删除', 102, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1017, '部门查询', 103, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1018, '部门新增', 103, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1019, '部门修改', 103, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1020, '部门删除', 103, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1021, '岗位查询', 104, 1, '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1022, '岗位新增', 104, 2, '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1023, '岗位修改', 104, 3, '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1024, '岗位删除', 104, 4, '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1025, '岗位导出', 104, 5, '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1026, '字典查询', 105, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1027, '字典新增', 105, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1028, '字典修改', 105, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1029, '字典删除', 105, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1030, '字典导出', 105, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1031, '参数查询', 106, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1032, '参数新增', 106, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1033, '参数修改', 106, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1034, '参数删除', 106, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1035, '参数导出', 106, 5, '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1036, '公告查询', 107, 1, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1037, '公告新增', 107, 2, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1038, '公告修改', 107, 3, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1039, '公告删除', 107, 4, '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2000, '数据资产', 0, 2, 'module', NULL, NULL, 1, 0, 'M', '0', '0', '', 'build', 'admin', '2022-03-10 13:53:58', 'admin', '2024-12-17 12:52:49', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2002, '模型申请', 2000, 2, 'modelApply', 'module/model/index', '{\"p\":10}', 1, 0, 'C', '0', '0', 'module:model:index', 'form', 'admin', '2022-09-09 16:27:55', 'admin', '2023-07-25 16:28:41', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2004, '模型审核', 2000, 3, 'modelAudit', 'module/model/index', '{\"p\":20}', 1, 0, 'C', '0', '0', 'module:model:index', 'link', 'admin', '2023-07-25 16:27:33', 'admin', '2023-07-25 16:28:50', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2005, '模型发布', 2000, 4, 'modelDeploy', 'module/model/index', '{\"p\":30}', 1, 0, 'C', '0', '0', 'module:model:index', 'guide', 'admin', '2023-07-25 16:30:18', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2006, '模型查询', 2000, 8, 'modelQuery', 'module/model/index', '{\"p\":40}', 1, 0, 'C', '0', '0', 'module:model:index', 'list', 'admin', '2023-07-25 16:32:43', 'admin', '2024-12-17 12:54:53', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2007, '数据中心', 0, 3, 'datax', NULL, NULL, 1, 0, 'M', '0', '0', '', 'redis', 'admin', '2024-12-17 12:51:46', 'admin', '2024-12-17 12:52:46', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2008, '供应商0001', 2007, 1, 'GYS0001', NULL, NULL, 1, 0, 'M', '0', '0', '', 'form', 'admin', '2024-12-17 12:59:07', 'admin', '2024-12-17 12:59:20', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2009, '供应商001申请', 2008, 1, 'apply', 'data/apply/index', '{\"a\":\"TEST01\",\"c\":\"GYS0001\"}', 1, 0, 'C', '0', '0', '', 'edit', 'admin', '2024-12-17 13:09:36', 'admin', '2024-12-17 13:14:50', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2010, '供应商0001审核', 2008, 2, 'audit', 'data/audit/index', '{\"a\":\"TEST01\",\"c\":\"GYS0001\"}', 1, 0, 'C', '0', '0', '', 'peoples', 'admin', '2024-12-17 13:11:57', 'admin', '2024-12-17 13:14:54', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2011, '供应商001查询', 2008, 3, 'query', 'data/query/index', '{\"a\":\"TEST01\",\"c\":\"GYS0001\"}', 1, 0, 'C', '0', '0', '', 'eye-open', 'admin', '2024-12-17 13:13:05', 'admin', '2024-12-17 13:14:59', '');
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `notice_id` int(4) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice_title` varchar(50) NOT NULL COMMENT '公告标题',
  `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）',
  `notice_content` longblob DEFAULT NULL COMMENT '公告内容',
  `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`notice_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='通知公告表';

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
INSERT INTO `sys_notice` (`notice_id`, `notice_title`, `notice_type`, `notice_content`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '温馨提醒：2020-07-01 若依新版本发布啦', '2', 0xE696B0E78988E69CACE58685E5AEB9, '0', 'admin', '2022-03-04 13:38:14', 'admin', '2022-03-07 14:17:37', '管理员');
INSERT INTO `sys_notice` (`notice_id`, `notice_title`, `notice_type`, `notice_content`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '维护通知：2018-07-01 若依系统凌晨维护', '1', 0xE7BBB4E68AA4E58685E5AEB9, '0', 'admin', '2022-03-04 13:38:14', '', NULL, '管理员');
COMMIT;

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数',
  `status` int(1) DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  PRIMARY KEY (`oper_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='操作日志记录';

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-07 13:53:24', '');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2022-03-04 13:38:13', '', NULL, '');
INSERT INTO `sys_post` (`post_id`, `post_code`, `post_name`, `post_sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2022-03-04 13:38:13', '', NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` tinyint(1) DEFAULT 1 COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) DEFAULT 1 COMMENT '部门树选择项是否关联显示',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2022-03-04 13:38:13', '', NULL, '超级管理员');
INSERT INTO `sys_role` (`role_id`, `role_name`, `role_key`, `role_sort`, `data_scope`, `menu_check_strictly`, `dept_check_strictly`, `status`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '普通角色', 'common', 2, '5', 1, 1, '0', '0', 'admin', '2022-03-04 13:38:13', 'admin', '2022-09-09 16:32:42', '普通角色');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 4);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 100);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 101);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 102);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 103);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 104);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 105);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 106);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 107);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1001);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1002);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1003);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1004);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1005);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1006);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1007);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1008);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1009);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1010);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1011);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1012);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1013);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1014);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1015);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1016);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1017);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1018);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1019);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1020);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1021);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1022);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1023);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1024);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1025);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1026);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1027);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1028);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1029);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1030);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1031);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1032);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1033);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1034);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1035);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1036);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1037);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1038);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 1039);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 2000);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (2, 2002);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `vip_level` int(6) DEFAULT 0 COMMENT '用户级别（字典sys_user_vip）',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `vip_level`, `status`, `del_flag`, `login_ip`, `login_date`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, 103, 'admin', '瓜瓜', '00', 'ry@163.com', '15888888888', '1', '', '667c756cf9334e328a56e44e906245c8e214c655a160f18fdb84d79c209c49cf', 0, '0', '0', '0:0:0:0:0:0:0:1', '2025-02-15 20:14:38', 'admin', '2022-03-04 13:38:13', '', '2025-02-15 12:14:38', '管理员');
INSERT INTO `sys_user` (`user_id`, `dept_id`, `user_name`, `nick_name`, `user_type`, `email`, `phonenumber`, `sex`, `avatar`, `password`, `vip_level`, `status`, `del_flag`, `login_ip`, `login_date`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, 105, 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', '', '667c756cf9334e328a56e44e906245c8e214c655a160f18fdb84d79c209c49cf', 1, '0', '0', '127.0.0.1', '2022-03-04 13:38:13', 'admin', '2022-03-04 13:38:13', 'admin', '2022-03-23 11:14:22', '测试员');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` (`user_id`, `post_id`) VALUES (1, 1);
INSERT INTO `sys_user_post` (`user_id`, `post_id`) VALUES (2, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1, 1);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (2, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
